package com.huangpuweb.api.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class SysBuildingInfoStreetRowMapper implements RowMapper<SysBuildingInfoStreet>{



	@Override
	public SysBuildingInfoStreet mapRow(ResultSet rs, int rowNum) throws SQLException {
		SysBuildingInfoStreet  lj= new SysBuildingInfoStreet();
		lj.setId(rs.getInt("id"));
//		lj.setArea(rs.getString("district"));
		lj.setStreet(rs.getString("street"));
		lj.setSerial_number(rs.getString("serial_number"));
		lj.setDepartment(rs.getString("unit"));
		lj.setName(rs.getString("site_name"));
		lj.setAddress(rs.getString("site_street"));
		lj.setStatus(rs.getString("status"));
		lj.setCreatetime(rs.getString("createtime"));
		lj.setNumber(rs.getInt("number"));
		lj.setFunctionary(rs.getString("functionary"));
		lj.setPhone(rs.getString("phone"));
		lj.setRemark(rs.getString("remark"));
		lj.setReseau_id(rs.getString("reseau_id"));
		lj.setLng(rs.getString("lng"));
		lj.setLat(rs.getString("lat"));
		lj.setPrice(rs.getString("price"));
		lj.setArea(rs.getString("area"));
		return lj;
	}

}
